<%@ page language="java" contentType="application/vnd.ms-excel; charset=UTF-8" %>
<%
	response.setHeader("Content-Type","application/vnd.ms-xls");
   	response.setHeader("Content-Disposition", "attachment; filename=StockStatus.xls");
%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%> 
<html>
<head>
	<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
</head>
<body>
	<table id="accountExcel_list" border="1" cellspacing='0' cellpadding='0' align="center">
		<tr style="background-color:yellow; font-size: 13pt"><td colspan="8"><b>ACTUAL STOCK LIST</b></td>
        </tr>
        <tr>
            <td>Shipper</td>
            <td><c:out value="${sShipperName}"/></td>
            <td>Messrs</td>
            <td><c:out value="${sMessrsName}"/></td>
            <td>Goods</td>
            <td colspan="3"><c:out value="${goodsName}"/></td>
        </tr>
        <tr>
            <td>Batch</td>
            <td><c:out value="${batchNo}"/></td>
            <td>Mawb</td>
            <td><c:out value="${mawb}"/></td>
            <td>Hawb</td>
            <td colspan="3"><c:out value="${hawb}"/></td>
        </tr>
        <tr>
            <td>Start Date</td>
            <td><c:out value="${sStartDate}"/></td>
            <td>Start Date</td>
            <td><c:out value="${sEndDate}"/></td>
            <td></td>
            <td colspan="3"></td>
        </tr>
        <tr>
            <td>Type1</td>
            <td colspan="7"><c:out value="${type1}"/></td>
        </tr>
        <tr>
            <td>Type2</td>
            <td colspan="7"><c:out value="${type2}"/></td>
        </tr>
        <tr>
            <td>Type3</td>
            <td colspan="7"><c:out value="${type3}"/></td>
        </tr>
        <tr><td colspan="8"></td>
        </tr>
        <tr style="background-color:gray; font-size: 11pt">
            <td>Div</td>
            <td>Date</td>
            <td>Goods</td>
            <td>Batch</td>
            <td>Cause</td>
            <td>Dam</td>
            <td>Loss</td>
            <td>Qty</td>
        </tr>
		<c:forEach items="${requestScope.resultList}" var="list" varStatus="status">
		      <tr height='55'>
                <td align="center"><c:out value="${list.divs}"/></td>
                <td align="center"><c:out value="${list.sDate}"/></td>
                <td align="center"><c:out value="${list.goodsName}"/></td>
                <td align="center"><c:out value="${list.batchNo}"/></td>
                <td align="center"><c:out value="${list.cause}"/></td>
                <td align="right"><c:out value="${list.damQty}"/></td>
                <td align="right"><c:out value="${list.lossQty}"/></td>
                <td align="right"><c:out value="${list.qty}"/></td>
            </tr>
		</c:forEach>
	</table>
</body>
</html>




